Ga naar hoofdinhoud

Reporting in Factview

This section describes the reporting functionality in Factview. In Factview, reports are displayed as views.

The following view types are available:

  • Factviews

  • Reportviews

  • Structureviews

  • Chartviews

  • Excelviews

What Is a View?​

A view is a dynamic presentation of data and consists of:

  • A selected Report Structure

  • The selected Dataset

  • Structure settings

  • Data settings

A view determines how data is presented, while the Report Structure determines what can be displayed.

Opening and Viewing Reports​

In the Factviews menu, all available reports are organized into tabs based on the report type.

Each report is displayed as a tile.

Click a tile to open the report in the Dashboard.

Dashboard

The Dashboard displays all open reports as tabs.

  • Each report opens in its own tab.

  • Reports remain open until they are closed manually.

  • Tabs can be dragged to change their order.

How a Report (View) Works​

To open and use a report:

  • Select a report via Open Reports → Open Reportviews → Factviews.

  • Choose a Dataset (fiscal year and data source).

  • Adjust the Report Structure and settings if needed.

The selected Dataset determines which figures are displayed in the report.

Complete the Mapping First​

Before reports can display the correct information, the mapping must be completed.

Mapping means linking:

  • General Ledger Accounts

  • To items in the Report Structure

This can be done:

  • Manually by dragging accounts.

  • Automatically using the red button (mapping algorithm).

Always review the mapping to ensure it is correct.

Reportviews​

Reportviews provide insight into an organization's financial performance.

  • The Performance Report evaluates the financial position based on predefined criteria.

  • The Analysis Report compares actual results with targets and benchmarks.

From these reports, you can drill down into the underlying figures.

Structureviews​

Structureviews allow you to create your own Report Structures.

For example:

  • A cash flow report.

  • A working capital overview.

This involves:

  • Creating a Report Structure.

  • Mapping General Ledger Accounts.

The Foundation: Report Structures​

Report Structures​

The Report Structure forms the foundation of every report.

In the Structure Layout menu, you can:

  • Create report structures.

  • View existing structures.

  • Modify report structures.

Structure Panel Layout​

The Structure Panel consists of three sections:

  • Structure Panel: Displays the layout of the Report Structure.

  • Accounts Panel: Lists the available General Ledger Accounts.

  • Options Panel: Contains settings and allows you to select report structures.

Standard Structure vs. Custom Structures​

The Standard Structure includes:

  • The Profit and Loss Statement.

  • The Balance Sheet.

It serves as the foundation for the standard reports.

Custom structures:

  • Do not need to be fully mapped.

  • Can be created for specific analyses.

Important​

The Standard Structure must always be fully mapped.

This is required for:

  • Accurate reporting.

  • Validation of the administration.

How the Structure Panel Works​

Report structures are organized into groups and hierarchy levels.

  • White triangle: Indicates that the group contains subgroups.

  • Black triangle: Indicates the lowest level in the hierarchy.

Use the Options menu to expand or collapse the entire structure at once.

Mapping General Ledger Accounts​

To map a General Ledger Account:

  • Drag an account from the Accounts Panel.

  • Drop it onto an M-group in the Report Structure.

Rules​

  • Structure numbers and their order must not be changed.

  • Only certain descriptions may be modified.

If an account is mapped incorrectly, it can easily be moved to the correct location.

Warning

**Important:** If a **General Ledger Account** is not mapped to an **M-group**, it will not appear in reports.

Always verify that all **General Ledger Accounts** are mapped correctly.